﻿@model IEnumerable<SQLResident.Models.Snapshot>

@{
    ViewBag.Title = "Index";
}
<ul class="breadcrumb">
    <li><a href="@Url.Action("Index","Home")">Inicio</a> <span class="divider">/</span></li>
    <li class="active">Instantánea de Procesos</li>
</ul>
<h2>Index</h2>

<p>
    @Html.ActionLink("Create New", "Create")
</p>
<table>
    <tr>
        <th>
            Server
        </th>
        <th>
            SPId
        </th>
        <th>
            Kpid
        </th>
        <th>
            Blocked
        </th>
        <th>
            LastWaitType
        </th>
        <th>
            waitresource
        </th>
        <th>
            dbid
        </th>
        <th>
            uid
        </th>
        <th>
            cpu
        </th>
        <th>
            physical_io
        </th>
        <th>
            memusage
        </th>
        <th>
            login_time
        </th>
        <th>
            last_batch
        </th>
        <th>
            ecid
        </th>
        <th>
            open_tran
        </th>
        <th>
            status
        </th>
        <th>
            hostname
        </th>
        <th>
            program_name
        </th>
        <th>
            hostprocess
        </th>
        <th>
            cmd
        </th>
        <th>
            nt_domain
        </th>
        <th>
            nt_username
        </th>
        <th>
            net_address
        </th>
        <th>
            net_library
        </th>
        <th>
            loginame
        </th>
        <th>
            stmt_start
        </th>
        <th>
            stmt_end
        </th>
        <th>
            request_id
        </th>
        <th></th>
    </tr>

@foreach (var item in Model) {
    <tr>
        <td>
            @Html.DisplayFor(modelItem => item.Server.Name)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.SPId)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.Kpid)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.Blocked)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.LastWaitType)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.waitresource)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.dbid)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.uid)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.cpu)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.physical_io)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.memusage)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.login_time)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.last_batch)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.ecid)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.open_tran)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.status)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.hostname)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.program_name)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.hostprocess)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.cmd)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.nt_domain)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.nt_username)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.net_address)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.net_library)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.loginame)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.stmt_start)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.stmt_end)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.request_id)
        </td>
        <td>
            @Html.ActionLink("Edit", "Edit", new { id=item.SnapshotId }) |
            @Html.ActionLink("Details", "Details", new { id=item.SnapshotId }) |
            @Html.ActionLink("Delete", "Delete", new { id=item.SnapshotId })
        </td>
    </tr>
}

</table>
